/*
 Navicat Premium Data Transfer

 Source Server         : zhiyundata-aliyun-北京
 Source Server Type    : MySQL
 Source Server Version : 50725
 Source Host           : rm-2ze83dmwmh18p67jtjo.mysql.rds.aliyuncs.com:3306
 Source Schema         : award2021_chhca

 Target Server Type    : MySQL
 Target Server Version : 50725
 File Encoding         : 65001

 Date: 10/03/2021 20:53:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `key` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string',
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`key`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` VALUES ('expert_review.begin_at', '2099-01-01 00:00:00', 'datetime', '网评开始时间');
INSERT INTO `sys_config` VALUES ('expert_review.end_at', '2099-01-01 00:00:00', 'datetime', '网评结束时间');
INSERT INTO `sys_config` VALUES ('sms_tasks', '{\n    \"expert_review_started\": {\n        \"tpl_name\": \"评审开始通知\",\n        \"scheduled_exec_at\": \"2099-01-01 10:00:00\",\n        \"cancel_after\": \"2099-01-01 18:00:00\",\n        \"executed_at\": null\n    },\n    \"expert_review_midterm\": {\n        \"tpl_name\": \"评审中期通知\",\n        \"scheduled_exec_at\": \"2099-01-01 10:00:00\",\n        \"cancel_after\": \"2099-01-01 18:00:00\",\n        \"executed_at\": null\n    },\n    \"expert_review_ending\": {\n        \"tpl_name\": \"评审临近结束通知\",\n        \"scheduled_exec_at\": \"2099-01-01 10:00:00\",\n        \"cancel_after\": \"2099-01-01 18:00:00\",\n        \"executed_at\": null,\n        \"remaining_days\": 3\n    }\n}', 'object', '发送短信任务');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
